Маълум бир рангдаги ячейкалар суммасини аниқлаш формуласи.
Excel таркибида афсуски бу формула мавжуд эмас, лекин уни макрослар ёрдамида яратиб олишимиз мумкин. Бунинг учун:
1️⃣ Янги файлни xlsm форматида сақлаб олинг. 2️⃣Alt + F11 бирикмасини босиб янги Модуль яратинг. 3️⃣ Қуйида кўрсатилган кодни кўчириб олиб модульни сақланг. 4️⃣ Формулани ишлатиш учун иккита критерий белгиланг: диапазон ва рангли ячейка. 5️⃣ Формула ҳисоблаши учун F9 клавишасини ишлатинг.
Public Function SummaRang(DataRange As Range,ColorSample As Range) As Double Dim Sum As Double Application.Volatile True
For Each cell In DataRange If cell.Interior.Color = ColorSample.Interior.Color Then Sum = Sum + cell.Value End If Next cell SummaRang = Sum End Function
Маълум бир рангдаги ячейкалар суммасини аниқлаш формуласи.
Excel таркибида афсуски бу формула мавжуд эмас, лекин уни макрослар ёрдамида яратиб олишимиз мумкин. Бунинг учун:
1️⃣ Янги файлни xlsm форматида сақлаб олинг. 2️⃣Alt + F11 бирикмасини босиб янги Модуль яратинг. 3️⃣ Қуйида кўрсатилган кодни кўчириб олиб модульни сақланг. 4️⃣ Формулани ишлатиш учун иккита критерий белгиланг: диапазон ва рангли ячейка. 5️⃣ Формула ҳисоблаши учун F9 клавишасини ишлатинг.
Public Function SummaRang(DataRange As Range,ColorSample As Range) As Double Dim Sum As Double Application.Volatile True
For Each cell In DataRange If cell.Interior.Color = ColorSample.Interior.Color Then Sum = Sum + cell.Value End If Next cell SummaRang = Sum End Function
Durov said on his Telegram channel today that the two and a half year blockchain and crypto project has been put to sleep. Ironically, after leaving Russia because the government wanted his encryption keys to his social media firm, Durov’s cryptocurrency idea lost steam because of a U.S. court. “The technology we created allowed for an open, free, decentralized exchange of value and ideas. TON had the potential to revolutionize how people store and transfer funds and information,” he wrote on his channel. “Unfortunately, a U.S. court stopped TON from happening.”
Can I mute a Telegram group?
In recent times, Telegram has gained a lot of popularity because of the controversy over WhatsApp’s new privacy policy. In January 2021, Telegram was the most downloaded app worldwide and crossed 500 million monthly active users. And with so many active users on the app, people might get messages in bulk from a group or a channel that can be a little irritating. So to get rid of the same, you can mute groups, chats, and channels on Telegram just like WhatsApp. You can mute notifications for one hour, eight hours, or two days, or you can disable notifications forever.
